package com.isoft.dao;

import com.isoft.entity.CounterDynamics;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CounterDynamicsDao {
    //两表连查
    @Select("select CKLS.ffid,CKLS.fide,CKLS.fatt,CKLS_CKLS.ddtm,CKLS_CKLS.fces," +
            "CKLS_CKLS.fcee,CKLS_CKLS.fcrs,CKLS_CKLS.fcre,CKLS_CKLS.fcdp," +
            "CKLS_CKLS.mcdp from CKLS join CKLS_CKLS on CKLS.id=CKLS_CKLS.id")
    public List<CounterDynamics> selectCounterDynamics();
}
